﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using ORS.DAL;


namespace ORS.BLL
{
    public class Getuserinformation
    {
        string sqlstr_user1,sqlstr_user2;
        static mssqlopr ivk_mssqlopr;

        static Getuserinformation()
        {
            ivk_mssqlopr = new mssqlopr();
        }
       
        public DataTable GetRegisteringUserInfo()
        {
            sqlstr_user1 = "SELECT a.*,b.name FROM tb_userlist a left join tb_role b ON a.roleid=b.roleid WHERE validflag=0";
            return ivk_mssqlopr.GetDataTable(sqlstr_user1);
        }

        public DataTable GetRegistedUserinfo()
        {
            sqlstr_user2 = "SELECT a.*,b.name FROM tb_userlist a left join tb_role b ON a.roleid=b.roleid WHERE validflag=1";
            return ivk_mssqlopr.GetDataTable(sqlstr_user2);
        }
    }
}

//  "SELECT a.*,b.cname FROM tb_paperinfo a left join tb_userlist b ON a.authorid=b.userid WHERE a.approvestate=1";